Open topic with navigation

You are here: Web Administration > Integration > Export Specifications > KS_INVENTORY

 

KS_INVENTORY

Ordinal

Description

Data
Type

Data
Length

Required

Check
Constraints

Comments

1

Part Number

string

25

Y

 

 

2

Site ID

string

5

Y

 

This field will also be used to create new warehouse/plant locations (Foreign Key Rows) automatically

3

Site Name

string

50

 

 

Only used if new warehouse/plant is created

4

Inventory
Location

string

10

Y

 

This field will also be used to create new inventory locations (Foreign Key rows) automatically

5

Location Name

string

50

 

 

Only used if new inventory location created

6

Quantity On Hand

decimal

14,4